﻿CREATE VIEW [acms].[UserPostUploadVote_View]
AS 
	SELECT 
		a.[Id],
		a.[UserId],
		a.[UserPostUploadId],
		b.[Title],
		b.[PostId],
		a.[Score],
		a.[Created],
		a.[ConcurencyId]
	FROM [acms].[UserPostUploadVote] a 
		inner join [acms].[UserPostUpload] b on a.[UserPostUploadId] = b.[Id]
	WHERE b.Deleted = 0
;